﻿# MySQL-Front 5.1  (Build 1.48)

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;


# Host: 127.0.0.1    Database: hero
# ------------------------------------------------------
# Server version 5.1.35-community

USE `hero`;

#
# Source for table open_tb_config
#

DROP TABLE IF EXISTS `open_tb_config`;
CREATE TABLE `open_tb_config` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `code` varchar(30) NOT NULL DEFAULT '',
  `type` varchar(10) NOT NULL DEFAULT '',
  `store_range` varchar(255) NOT NULL DEFAULT '',
  `store_dir` varchar(255) NOT NULL DEFAULT '',
  `value` text NOT NULL,
  `sort_order` tinyint(3) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`),
  KEY `parent_id` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

#
# Dumping data for table open_tb_config
#
LOCK TABLES `open_tb_config` WRITE;
/*!40000 ALTER TABLE `open_tb_config` DISABLE KEYS */;

INSERT INTO `open_tb_config` VALUES (1,0,'tb_search','text','','','',1);
INSERT INTO `open_tb_config` VALUES (2,0,'lock_tag','text','','','[000]',1);
INSERT INTO `open_tb_config` VALUES (3,0,'status','text','','','WAIT_BUYER_PAY;TRADE_NO_CREATE_PAY;WAIT_BUYER_CONFIRM_GOODS;WAIT_SELLER_SEND_GOODS;',1);
/*!40000 ALTER TABLE `open_tb_config` ENABLE KEYS */;
UNLOCK TABLES;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
